<?php

use Illuminate\Database\Seeder;

class AuthorsTableSeeder extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
        DB::insert("
            INSERT INTO `authors` (`id`, `article_id`, `title_id`, `firstname`, `middlename`, `lastname`, `email`, `affiliation`, `correspondence`, `correspondence_introduction`, `created_at`, `updated_at`) VALUES
(1, 1, NULL, 'Gu', NULL, 'Fang', 'qixg@nwu.edu.cn', '1', 1, NULL, '2018-06-15 02:50:45', '2018-06-15 02:50:45'),
(2, 1, NULL, 'Jing', NULL, 'Chen', 'qixg@nwu.edu.cn', '1', 1, NULL, '2018-06-15 02:50:45', '2018-06-15 02:50:45'),
(3, 1, NULL, 'Ru-Liang', NULL, 'Pan', 'qixg@nwu.edu.cn', '1,2,3', 1, NULL, '2018-06-15 02:50:45', '2018-06-15 02:50:45'),
(4, 1, NULL, 'Xiao-Guang', NULL, 'Qi', 'qixg@nwu.edu.cn', '1,2', 1, NULL, '2018-06-15 02:50:45', '2018-06-15 02:50:45'),
(5, 1, NULL, 'Bao-Guo', NULL, 'Li', 'qixg@nwu.edu.cn', '1,2', 1, NULL, '2018-06-15 02:50:45', '2018-06-15 02:50:45'),
(6, 2, NULL, 'Kaitlin R.', NULL, 'Wright', 'jhli@ahu.edu.cn', '1', 1, NULL, '2018-06-15 02:57:31', '2018-06-15 02:57:31'),
(7, 2, NULL, 'Jessica A.', NULL, 'Mayhew', 'jhli@ahu.edu.cn', '1,2', 1, NULL, '2018-06-15 02:57:31', '2018-06-15 02:57:31'),
(8, 2, NULL, 'Lori K.', NULL, 'Sheeran', 'jhli@ahu.edu.cn', '1,2,3', 1, NULL, '2018-06-15 02:57:31', '2018-06-15 02:57:31'),
(9, 2, NULL, 'Jake A.', NULL, 'Funkhouser', 'jhli@ahu.edu.cn', '2,4', 1, NULL, '2018-06-15 02:57:31', '2018-06-15 02:57:31'),
(10, 2, NULL, 'Ronald. S.', NULL, 'Wagner', 'jhli@ahu.edu.cn', '1,2,3,4', 1, NULL, '2018-06-15 02:57:31', '2018-06-15 02:57:31'),
(11, 3, NULL, 'Gu', NULL, 'Fang', 'qixg@nwu.edu.cn', '1', 1, NULL, '2018-06-15 03:00:52', '2018-06-15 03:00:52'),
(12, 3, NULL, 'Ru-Liang', NULL, 'Pan', 'qixg@nwu.edu.cn', '1,2,3', 1, NULL, '2018-06-15 03:00:52', '2018-06-15 03:00:52'),
(13, 3, NULL, 'Xiao-Guang', NULL, 'Qi', 'qixg@nwu.edu.cn', '2,3', 1, NULL, '2018-06-15 03:00:52', '2018-06-15 03:00:52'),
(14, 4, NULL, 'Kaitlin R.', NULL, 'Wright', 'jhli@ahu.edu.cn', '1', 1, NULL, '2018-06-15 03:04:50', '2018-06-15 03:04:50'),
(15, 4, NULL, 'Jessica A.', NULL, 'Mayhew', 'jhli@ahu.edu.cn', '1,2', 1, NULL, '2018-06-15 03:04:50', '2018-06-15 03:04:50'),
(16, 4, NULL, 'Lori K.', NULL, 'Sheeran', 'jhli@ahu.edu.cn', '1,2,3', 1, NULL, '2018-06-15 03:04:50', '2018-06-15 03:04:50'),
(17, 4, NULL, 'Ronald. S.', NULL, 'Wagner', 'jhli@ahu.edu.cn', '1,2,3,4', 1, NULL, '2018-06-15 03:04:50', '2018-06-15 03:04:50'),
(18, 5, NULL, 'Gu', NULL, 'Fang', 'qixg@nwu.edu.cn', '1', 1, NULL, '2018-06-15 03:08:56', '2018-06-15 03:08:56'),
(19, 5, NULL, 'Ru-Liang', NULL, 'Pan', 'qixg@nwu.edu.cn', '1,2,3', 1, NULL, '2018-06-15 03:08:56', '2018-06-15 03:08:56'),
(20, 5, NULL, 'Xiao-Guang', NULL, 'Qi', 'qixg@nwu.edu.cn', '2,3', 1, NULL, '2018-06-15 03:08:56', '2018-06-15 03:08:56')
            ");
    }
}
